﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;

public partial class SchemaDB_Manufacturers : System.Web.UI.UserControl
{

	public SchemaDB_Manufacturers()
	{
		this.Title = "Manufacturers";
	}

	public string Title
	{
		get;
		set;
	}

	protected void Page_Load(object sender, EventArgs e)
	{
		using (var conn = new SqlConnection(Settings.ConnectionString))
		{
			conn.Open();

/*			this.NumberUploadedSchemas.InnerText = new SqlCommand()
			{
				Connection = conn,
				CommandType = System.Data.CommandType.Text,
				CommandText = "select count(*) from DeviceDom where DomType='d'"

			}.ExecuteScalar().ToString();


			this.NumberInstallations.InnerText = new SqlCommand()
			{
				Connection = conn,
				CommandType = System.Data.CommandType.Text,
				CommandText = "select sum(CheckCount) from UpdateCheckDW where CheckDay=convert(varchar(50),current_timestamp-1,112)"

			}.ExecuteScalar().ToString();*/
			
		}
	}
}
